select * from Loan_auto_document

select * from TBL_CHECKLIST_DOCUMENT order by checklist_doc_id




INSERT [dbo].[TBL_CHECKLIST_DOCUMENT]
           ([Document_group_category]
           ,[Document_group]
           ,[Document]
           ,[original]
           ,[Copy]
           ,[Duplicate]
           ,[Note]
           ,[Picture_document]
           ,[PRODUCT_ID]
           ,[sub_product_name])
 SELECT [Document_group_category]
      ,[Document_group]
      ,[Document]
      ,[original]
      ,[Copy]
      ,[Duplicate]
      ,[Note]
      ,[Picture_document]
	  ,22
      ,[sub_product_name]
  FROM [dbo].[Loan_auto_document]

delete from TBL_CHECKLIST_DOCUMENT


select * from TBL_CHECKLIST_DOCUMENT

update TBL_CHECKLIST_DOCUMENT 
set sub_product_name = 1 where sub_product_name = 'Loan Auto A1'

select * from TBL_CHECKLIST_QUESTION_SUB_PRODUCT_RESULT

select * from TBL_CHECKLIST_CUSTOMER

update TBL_CHECKLIST_CUSTOMER set  sub_product_name = 'Loan Auto A2'where sub_product_id = '2'

select * from TBL_CHECKLIST_SUB_PRODUCT


select * from TBL_Checklist_Question

select * from TBL_CHECKLIST_QUESTION_SUB_PRODUCT_RESULT

select * from TBL_CHECKLIST_DOCUMENT_BY_CUSTOMER where CCID ='1481024984'

delete from server12.SMECustomer360.[dbo].TBL_CHECKLIST_DOCUMENT
insert server12.SMECustomer360.dbo.TBL_CHECKLIST_DOCUMENT
select * from TBL_CHECKLIST_DOCUMENT


delete from server12.SMECustomer360.[dbo].[TBL_CHECKLIST_QUESTION_SUB_PRODUCT_RESULT]
insert server12.SMECustomer360.dbo.[TBL_CHECKLIST_QUESTION_SUB_PRODUCT_RESULT]
select * from [TBL_CHECKLIST_QUESTION_SUB_PRODUCT_RESULT]

delete from server12.SMECustomer360.[dbo].[TBL_CHECKLIST_SUB_PRODUCT]
insert server12.SMECustomer360.dbo.[TBL_CHECKLIST_SUB_PRODUCT]
select * from [TBL_CHECKLIST_SUB_PRODUCT]


delete from server12.SMECustomer360.[dbo].[TBL_CHECKLIST_DOC_HIDE_ANSWER]
insert server12.SMECustomer360.dbo.[TBL_CHECKLIST_DOC_HIDE_ANSWER]
select * from [TBL_CHECKLIST_DOC_HIDE_ANSWER]

delete from server12.SMECustomer360.[dbo].[TBL_Checklist_Question]
insert server12.SMECustomer360.dbo.[TBL_Checklist_Question]
select * from [TBL_Checklist_Question]

delete from server12.SMECustomer360.[dbo].[TBL_CHECKLIST_SUB_PRODUCT]
insert server12.SMECustomer360.dbo.[TBL_CHECKLIST_SUB_PRODUCT]
select * from [TBL_CHECKLIST_SUB_PRODUCT]

delete from server12.SMECustomer360.[dbo].[TBL_CHECKLIST_CUSTOMER]
insert server12.SMECustomer360.dbo.[TBL_CHECKLIST_CUSTOMER]	
select * from [TBL_CHECKLIST_CUSTOMER]

delete from server12.SMECustomer360.[dbo].[TBL_CHECKLIST_DOCUMENT_BY_CUSTOMER]
insert server12.SMECustomer360.dbo.[TBL_CHECKLIST_DOCUMENT_BY_CUSTOMER]
select * from [TBL_CHECKLIST_DOCUMENT_BY_CUSTOMER]